Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_11

R_11

Event

ExternalServiceResource

EventID

 

 

R_70

R_70

Service

LServServ

ServID

 

 

R_150

R_150

Language

PerfServStatusText

LanguageID

 

 

R_186

R_186

Service

LOrgUnitServ

ServID

 

 

R_215

R_215

Service

LServPerfServ

ServID

 

 

R_309

R_309

ServiceType

Service

ServiceTypeID

 

 

R_310

R_310

Language

UnitText

LanguageID

 

 

R_311

R_311

Unit

UnitText

UnitID

 

 

R_313

R_313

ServiceType

ServiceTypeText

ServiceTypeID

 

 

R_314

R_314

Unit

ExternalServiceResource

UnitID

 

 

R_341

R_341

ResourceItem

LServRes

ResourceID

 

 

R_342

R_342

Service

LServRes

ServID

 

 

R_401

R_401

Personnel

MedResource

PersonID

 

 

R_491

R_491

Unit

LServRes

UnitID

 

 

R_498

R_498

ICD

Service

ICDID

 

 

R_499

R_499

Personnel

LPersonnelPerfService

PersonID

 

 

R_500

R_500

PerfService

LPersonnelPerfService

PerfServiceID

 

 

R_503

R_503

ICD

PerfService

ICDID

 

 

R_505

R_505

PersonnelFunction

LPersonnelPerfService

PersonnelFunctionID

 

 

R_506

R_506

PersonnelFunction

PersonnelFunctionText

PersonnelFunctionID

 

 

R_507

R_507

Language

PersonnelFunctionText

LanguageID

 

 

R_566

R_566

UnitType

Unit

UnitTypeID

 

 

R_567

R_567

UnitType

UnitTypeText

UnitTypeID

 

 

R_571

R_571

Language

UnitTypeText

LanguageID

 

 

R_585

R_585

Service

ServiceAddOns

ServID

 

 

R_611

R_611

Service

PerfService

ServID

 

 

R_664

R_664

PerfService

LServPerfServ

PerfServiceID

 

 

R_669

R_669

PerfServiceStatus

PerfServStatusText

PerfServiceStatusID

 

 

R_677

R_677

Service

LServServ

Ser_ServID

 

 

R_682

R_682

Unit

Service

UnitID

 

 

R_683

R_683

Unit

LServServ

UnitID

 

 

R_761

R_761

Service

LServiceICD

ServID

 

 

R_762

R_762

ICD

LServiceICD

ICDID

 

 

R_763

R_763

ICD

LPerfServiceICD

ICDID

 

 

R_764

R_764

PerfService

LPerfServiceICD

PerfServiceID

 

 

R_906

R_906

Frequency

PerfService

FrequencyID

 

 

R_998

R_998

ResourceItem

LMedResourceItem

ResourceID

 

 

R_999

R_999

MedResource

LMedResourceItem

MedResourceID

 

 

R_1000

R_1000

Service

LServMedRes

ServID

 

 

R_1001

R_1001

MedResource

LServMedRes

MedResourceID

 

 

R_1435

R_1435

PerfTemplate

LPerfTemplateServ

PerfTemplateID

 

 

R_1436

R_1436

Service

ExternalServiceResource

ServID

 

 

R_1437

R_1437

Service

LPerfTemplateServ

ServID

 

 

R_1438

R_1438

PerfTemplate

LPerfTemplateResource

PerfTemplateID

 

 

R_1439

R_1439

ResourceItem

LPerfTemplateResource

ResourceID

 

 

R_1440

R_1440

PerfTemplate

Service

PerfTemplateID

 

 

R_1513

R_1513

VATRate

Service

VatRateID

 

 

R_1533

R_1533

ServiceType

ServiceType

Serv_ServiceTypeID

 

 

R_3090

R_3090

UserType

LPersonnelPerfService

UserTypeID

 

 

R_7011

R_7011

VATRate

LServiceVatRate

VatRateID

 

 


2